create database univ12;

use univ12;

create table person 
  (num		char(9)  primary key, 
   lastname	varchar(12) not null,		/* varying length string */
   firstname	varchar(12));

create table prof
  (pnum		char(9) primary key,		/* fixed length string */ 
   lastname	varchar(12) not null,		/* varying length string */
   firstname	varchar(12), 
   dept		char(4), 
   office	char(6), 
   rank		char(1), 
   date_emp	date  not null,		 
   salary    	decimal(8,2), 
   manager	char(9));

create table student
  (snum	char(9)  primary key,
   lastname varchar(12) not null,		/* varying length string */
   firstname	varchar(12), 
   dept		char(4),
   date_ent	date,
   cr_comp	smallint,
   GPA		decimal(3,2),
   advisor	char(9));

create table course
  (cnum		char(6)  primary key,
   name		varchar(64) not null,
   descr	varchar(256),
   dept		char(4) not null,
   level	smallint,
   credits	smallint);

create table section
  (cnum		char(6)  not null,
   secnum	char(4),   
   pnum		char(9),
   term		char(3),
   primary key (secnum, term));

create table report
  (snum		char(9),
   secnum	char(4),
   term		char(3),
   grade	char(1),
   primary key (snum, secnum, term));